##--ProfessionNPC
DELETE FROM creature_template WHERE `entry`=90001;
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) values('90001','0','7061','0','7061','0','Profession Employee','ProfessionNPC Master',NULL,'80','80','25000','25000','0','0','10000','35','35','1','1','1.5','1','1763','1763','0','1511','1','1000','0','0','0','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','0','1','0','0','0','professionnpc');

DELETE FROM creature_ai_scripts WHERE `creature_id`=90001;
insert into creature_ai_scripts values(NULL, '90001', '1', '0', '100', '1', '25000', '25000','600000','600000', '1', '-910', '-911', '-912', '0', '0', '0', '0', '0', '0', '0', '0', 'ProfessionNPC - Random Say');


DELETE FROM creature_ai_texts WHERE `entry`=-910;
REPLACE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `comment`) 
VALUES (-910, 'Hello!I am Professioneer and I am hired CHANGE THIS IN CREATURE AI TEXTS to Increase Profesion Skill with points in exchange for some gold!', 0, 0, 0, 'ProfessionNPC message one');

DELETE FROM creature_ai_texts WHERE `entry`=-911;
REPLACE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `comment`) 
VALUES (-911, 'Having trouble leveling your favourite profession ? Come to me! A small "donation" always helps.', 0, 0, 0, 'ProfessionNPC message two');

DELETE FROM creature_ai_texts WHERE `entry`=-912;
REPLACE INTO `creature_ai_texts` (`entry`, `content_default`, `sound`, `type`, `language`, `comment`) 
VALUES (-912, 'Time is business, so hurry up will ya...', 0, 0, 0, 'ProfessionNPC message three');

UPDATE creature_template SET AIName='EventAI' WHERE entry=90001;